package com.fc.v2.model.auto;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import cn.hutool.core.util.StrUtil;

/**
 * 检测信息 DetectionExample
 * @author cjh_自动生成
 * @date 2025-01-29 19:14:18
 */
public class DetectionExample {

    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public DetectionExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }


    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }
        
		
        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }
        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }
        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(Integer value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(Integer value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdInStr(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }
        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }
        
		
        public Criteria andCustomerIsNull() {
            addCriterion("customer is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIsNotNull() {
            addCriterion("customer is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerEqualTo(String value) {
            addCriterion("customer =", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotEqualTo(String value) {
            addCriterion("customer <>", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerGreaterThan(String value) {
            addCriterion("customer >", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerGreaterThanOrEqualTo(String value) {
            addCriterion("customer >=", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerLessThan(String value) {
            addCriterion("customer <", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerLessThanOrEqualTo(String value) {
            addCriterion("customer <=", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerLike(String value) {
            addCriterion("customer like", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotLike(String value) {
            addCriterion("customer not like", value, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerIn(List<String> values) {
            addCriterion("customer in", values, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotIn(List<String> values) {
            addCriterion("customer not in", values, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerBetween(String value1, String value2) {
            addCriterion("customer between", value1, value2, "customer");
            return (Criteria) this;
        }

        public Criteria andCustomerNotBetween(String value1, String value2) {
            addCriterion("customer not between", value1, value2, "customer");
            return (Criteria) this;
        }
        
		
        public Criteria andModelspecificationsIsNull() {
            addCriterion("modelspecifications is null");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsIsNotNull() {
            addCriterion("modelspecifications is not null");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsEqualTo(String value) {
            addCriterion("modelspecifications =", value, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsNotEqualTo(String value) {
            addCriterion("modelspecifications <>", value, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsGreaterThan(String value) {
            addCriterion("modelspecifications >", value, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsGreaterThanOrEqualTo(String value) {
            addCriterion("modelspecifications >=", value, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsLessThan(String value) {
            addCriterion("modelspecifications <", value, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsLessThanOrEqualTo(String value) {
            addCriterion("modelspecifications <=", value, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsLike(String value) {
            addCriterion("modelspecifications like", value, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsNotLike(String value) {
            addCriterion("modelspecifications not like", value, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsIn(List<String> values) {
            addCriterion("modelspecifications in", values, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsNotIn(List<String> values) {
            addCriterion("modelspecifications not in", values, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsBetween(String value1, String value2) {
            addCriterion("modelspecifications between", value1, value2, "modelspecifications");
            return (Criteria) this;
        }

        public Criteria andModelspecificationsNotBetween(String value1, String value2) {
            addCriterion("modelspecifications not between", value1, value2, "modelspecifications");
            return (Criteria) this;
        }
        
		
        public Criteria andTasknoIsNull() {
            addCriterion("taskno is null");
            return (Criteria) this;
        }

        public Criteria andTasknoIsNotNull() {
            addCriterion("taskno is not null");
            return (Criteria) this;
        }

        public Criteria andTasknoEqualTo(String value) {
            addCriterion("taskno =", value, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoNotEqualTo(String value) {
            addCriterion("taskno <>", value, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoGreaterThan(String value) {
            addCriterion("taskno >", value, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoGreaterThanOrEqualTo(String value) {
            addCriterion("taskno >=", value, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoLessThan(String value) {
            addCriterion("taskno <", value, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoLessThanOrEqualTo(String value) {
            addCriterion("taskno <=", value, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoLike(String value) {
            addCriterion("taskno like", value, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoNotLike(String value) {
            addCriterion("taskno not like", value, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoIn(List<String> values) {
            addCriterion("taskno in", values, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoNotIn(List<String> values) {
            addCriterion("taskno not in", values, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoBetween(String value1, String value2) {
            addCriterion("taskno between", value1, value2, "taskno");
            return (Criteria) this;
        }

        public Criteria andTasknoNotBetween(String value1, String value2) {
            addCriterion("taskno not between", value1, value2, "taskno");
            return (Criteria) this;
        }
        
		
        public Criteria andManufacturerIsNull() {
            addCriterion("manufacturer is null");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNotNull() {
            addCriterion("manufacturer is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturerEqualTo(String value) {
            addCriterion("manufacturer =", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotEqualTo(String value) {
            addCriterion("manufacturer <>", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThan(String value) {
            addCriterion("manufacturer >", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("manufacturer >=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThan(String value) {
            addCriterion("manufacturer <", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThanOrEqualTo(String value) {
            addCriterion("manufacturer <=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLike(String value) {
            addCriterion("manufacturer like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotLike(String value) {
            addCriterion("manufacturer not like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerIn(List<String> values) {
            addCriterion("manufacturer in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotIn(List<String> values) {
            addCriterion("manufacturer not in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerBetween(String value1, String value2) {
            addCriterion("manufacturer between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotBetween(String value1, String value2) {
            addCriterion("manufacturer not between", value1, value2, "manufacturer");
            return (Criteria) this;
        }
        
		
        public Criteria andMpe1IsNull() {
            addCriterion("mpe1 is null");
            return (Criteria) this;
        }

        public Criteria andMpe1IsNotNull() {
            addCriterion("mpe1 is not null");
            return (Criteria) this;
        }

        public Criteria andMpe1EqualTo(String value) {
            addCriterion("mpe1 =", value, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1NotEqualTo(String value) {
            addCriterion("mpe1 <>", value, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1GreaterThan(String value) {
            addCriterion("mpe1 >", value, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1GreaterThanOrEqualTo(String value) {
            addCriterion("mpe1 >=", value, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1LessThan(String value) {
            addCriterion("mpe1 <", value, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1LessThanOrEqualTo(String value) {
            addCriterion("mpe1 <=", value, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1Like(String value) {
            addCriterion("mpe1 like", value, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1NotLike(String value) {
            addCriterion("mpe1 not like", value, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1In(List<String> values) {
            addCriterion("mpe1 in", values, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1NotIn(List<String> values) {
            addCriterion("mpe1 not in", values, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1Between(String value1, String value2) {
            addCriterion("mpe1 between", value1, value2, "mpe1");
            return (Criteria) this;
        }

        public Criteria andMpe1NotBetween(String value1, String value2) {
            addCriterion("mpe1 not between", value1, value2, "mpe1");
            return (Criteria) this;
        }
        
		
        public Criteria andExitnumIsNull() {
            addCriterion("exitnum is null");
            return (Criteria) this;
        }

        public Criteria andExitnumIsNotNull() {
            addCriterion("exitnum is not null");
            return (Criteria) this;
        }

        public Criteria andExitnumEqualTo(String value) {
            addCriterion("exitnum =", value, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumNotEqualTo(String value) {
            addCriterion("exitnum <>", value, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumGreaterThan(String value) {
            addCriterion("exitnum >", value, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumGreaterThanOrEqualTo(String value) {
            addCriterion("exitnum >=", value, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumLessThan(String value) {
            addCriterion("exitnum <", value, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumLessThanOrEqualTo(String value) {
            addCriterion("exitnum <=", value, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumLike(String value) {
            addCriterion("exitnum like", value, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumNotLike(String value) {
            addCriterion("exitnum not like", value, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumIn(List<String> values) {
            addCriterion("exitnum in", values, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumNotIn(List<String> values) {
            addCriterion("exitnum not in", values, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumBetween(String value1, String value2) {
            addCriterion("exitnum between", value1, value2, "exitnum");
            return (Criteria) this;
        }

        public Criteria andExitnumNotBetween(String value1, String value2) {
            addCriterion("exitnum not between", value1, value2, "exitnum");
            return (Criteria) this;
        }
        
		
        public Criteria andMainstandardIsNull() {
            addCriterion("mainstandard is null");
            return (Criteria) this;
        }

        public Criteria andMainstandardIsNotNull() {
            addCriterion("mainstandard is not null");
            return (Criteria) this;
        }

        public Criteria andMainstandardEqualTo(String value) {
            addCriterion("mainstandard =", value, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardNotEqualTo(String value) {
            addCriterion("mainstandard <>", value, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardGreaterThan(String value) {
            addCriterion("mainstandard >", value, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardGreaterThanOrEqualTo(String value) {
            addCriterion("mainstandard >=", value, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardLessThan(String value) {
            addCriterion("mainstandard <", value, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardLessThanOrEqualTo(String value) {
            addCriterion("mainstandard <=", value, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardLike(String value) {
            addCriterion("mainstandard like", value, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardNotLike(String value) {
            addCriterion("mainstandard not like", value, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardIn(List<String> values) {
            addCriterion("mainstandard in", values, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardNotIn(List<String> values) {
            addCriterion("mainstandard not in", values, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardBetween(String value1, String value2) {
            addCriterion("mainstandard between", value1, value2, "mainstandard");
            return (Criteria) this;
        }

        public Criteria andMainstandardNotBetween(String value1, String value2) {
            addCriterion("mainstandard not between", value1, value2, "mainstandard");
            return (Criteria) this;
        }
        
		
        public Criteria andMrangeIsNull() {
            addCriterion("mrange is null");
            return (Criteria) this;
        }

        public Criteria andMrangeIsNotNull() {
            addCriterion("mrange is not null");
            return (Criteria) this;
        }

        public Criteria andMrangeEqualTo(String value) {
            addCriterion("mrange =", value, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeNotEqualTo(String value) {
            addCriterion("mrange <>", value, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeGreaterThan(String value) {
            addCriterion("mrange >", value, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeGreaterThanOrEqualTo(String value) {
            addCriterion("mrange >=", value, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeLessThan(String value) {
            addCriterion("mrange <", value, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeLessThanOrEqualTo(String value) {
            addCriterion("mrange <=", value, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeLike(String value) {
            addCriterion("mrange like", value, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeNotLike(String value) {
            addCriterion("mrange not like", value, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeIn(List<String> values) {
            addCriterion("mrange in", values, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeNotIn(List<String> values) {
            addCriterion("mrange not in", values, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeBetween(String value1, String value2) {
            addCriterion("mrange between", value1, value2, "mrange");
            return (Criteria) this;
        }

        public Criteria andMrangeNotBetween(String value1, String value2) {
            addCriterion("mrange not between", value1, value2, "mrange");
            return (Criteria) this;
        }
        
		
        public Criteria andMpe2IsNull() {
            addCriterion("mpe2 is null");
            return (Criteria) this;
        }

        public Criteria andMpe2IsNotNull() {
            addCriterion("mpe2 is not null");
            return (Criteria) this;
        }

        public Criteria andMpe2EqualTo(String value) {
            addCriterion("mpe2 =", value, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2NotEqualTo(String value) {
            addCriterion("mpe2 <>", value, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2GreaterThan(String value) {
            addCriterion("mpe2 >", value, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2GreaterThanOrEqualTo(String value) {
            addCriterion("mpe2 >=", value, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2LessThan(String value) {
            addCriterion("mpe2 <", value, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2LessThanOrEqualTo(String value) {
            addCriterion("mpe2 <=", value, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2Like(String value) {
            addCriterion("mpe2 like", value, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2NotLike(String value) {
            addCriterion("mpe2 not like", value, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2In(List<String> values) {
            addCriterion("mpe2 in", values, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2NotIn(List<String> values) {
            addCriterion("mpe2 not in", values, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2Between(String value1, String value2) {
            addCriterion("mpe2 between", value1, value2, "mpe2");
            return (Criteria) this;
        }

        public Criteria andMpe2NotBetween(String value1, String value2) {
            addCriterion("mpe2 not between", value1, value2, "mpe2");
            return (Criteria) this;
        }
        
		
        public Criteria andCertificatenoIsNull() {
            addCriterion("certificateno is null");
            return (Criteria) this;
        }

        public Criteria andCertificatenoIsNotNull() {
            addCriterion("certificateno is not null");
            return (Criteria) this;
        }

        public Criteria andCertificatenoEqualTo(String value) {
            addCriterion("certificateno =", value, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoNotEqualTo(String value) {
            addCriterion("certificateno <>", value, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoGreaterThan(String value) {
            addCriterion("certificateno >", value, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoGreaterThanOrEqualTo(String value) {
            addCriterion("certificateno >=", value, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoLessThan(String value) {
            addCriterion("certificateno <", value, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoLessThanOrEqualTo(String value) {
            addCriterion("certificateno <=", value, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoLike(String value) {
            addCriterion("certificateno like", value, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoNotLike(String value) {
            addCriterion("certificateno not like", value, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoIn(List<String> values) {
            addCriterion("certificateno in", values, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoNotIn(List<String> values) {
            addCriterion("certificateno not in", values, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoBetween(String value1, String value2) {
            addCriterion("certificateno between", value1, value2, "certificateno");
            return (Criteria) this;
        }

        public Criteria andCertificatenoNotBetween(String value1, String value2) {
            addCriterion("certificateno not between", value1, value2, "certificateno");
            return (Criteria) this;
        }
        
		
        public Criteria andSmwIsNull() {
            addCriterion("smw is null");
            return (Criteria) this;
        }

        public Criteria andSmwIsNotNull() {
            addCriterion("smw is not null");
            return (Criteria) this;
        }

        public Criteria andSmwEqualTo(String value) {
            addCriterion("smw =", value, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwNotEqualTo(String value) {
            addCriterion("smw <>", value, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwGreaterThan(String value) {
            addCriterion("smw >", value, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwGreaterThanOrEqualTo(String value) {
            addCriterion("smw >=", value, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwLessThan(String value) {
            addCriterion("smw <", value, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwLessThanOrEqualTo(String value) {
            addCriterion("smw <=", value, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwLike(String value) {
            addCriterion("smw like", value, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwNotLike(String value) {
            addCriterion("smw not like", value, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwIn(List<String> values) {
            addCriterion("smw in", values, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwNotIn(List<String> values) {
            addCriterion("smw not in", values, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwBetween(String value1, String value2) {
            addCriterion("smw between", value1, value2, "smw");
            return (Criteria) this;
        }

        public Criteria andSmwNotBetween(String value1, String value2) {
            addCriterion("smw not between", value1, value2, "smw");
            return (Criteria) this;
        }
        
		
        public Criteria andCertificateutilIsNull() {
            addCriterion("certificateutil is null");
            return (Criteria) this;
        }

        public Criteria andCertificateutilIsNotNull() {
            addCriterion("certificateutil is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateutilEqualTo(String value) {
            addCriterion("certificateutil =", value, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilNotEqualTo(String value) {
            addCriterion("certificateutil <>", value, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilGreaterThan(String value) {
            addCriterion("certificateutil >", value, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilGreaterThanOrEqualTo(String value) {
            addCriterion("certificateutil >=", value, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilLessThan(String value) {
            addCriterion("certificateutil <", value, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilLessThanOrEqualTo(String value) {
            addCriterion("certificateutil <=", value, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilLike(String value) {
            addCriterion("certificateutil like", value, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilNotLike(String value) {
            addCriterion("certificateutil not like", value, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilIn(List<String> values) {
            addCriterion("certificateutil in", values, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilNotIn(List<String> values) {
            addCriterion("certificateutil not in", values, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilBetween(String value1, String value2) {
            addCriterion("certificateutil between", value1, value2, "certificateutil");
            return (Criteria) this;
        }

        public Criteria andCertificateutilNotBetween(String value1, String value2) {
            addCriterion("certificateutil not between", value1, value2, "certificateutil");
            return (Criteria) this;
        }
        
		
        public Criteria andTemperatureIsNull() {
            addCriterion("temperature is null");
            return (Criteria) this;
        }

        public Criteria andTemperatureIsNotNull() {
            addCriterion("temperature is not null");
            return (Criteria) this;
        }

        public Criteria andTemperatureEqualTo(String value) {
            addCriterion("temperature =", value, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureNotEqualTo(String value) {
            addCriterion("temperature <>", value, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureGreaterThan(String value) {
            addCriterion("temperature >", value, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureGreaterThanOrEqualTo(String value) {
            addCriterion("temperature >=", value, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureLessThan(String value) {
            addCriterion("temperature <", value, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureLessThanOrEqualTo(String value) {
            addCriterion("temperature <=", value, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureLike(String value) {
            addCriterion("temperature like", value, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureNotLike(String value) {
            addCriterion("temperature not like", value, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureIn(List<String> values) {
            addCriterion("temperature in", values, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureNotIn(List<String> values) {
            addCriterion("temperature not in", values, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureBetween(String value1, String value2) {
            addCriterion("temperature between", value1, value2, "temperature");
            return (Criteria) this;
        }

        public Criteria andTemperatureNotBetween(String value1, String value2) {
            addCriterion("temperature not between", value1, value2, "temperature");
            return (Criteria) this;
        }
        
		
        public Criteria andHumidityIsNull() {
            addCriterion("humidity is null");
            return (Criteria) this;
        }

        public Criteria andHumidityIsNotNull() {
            addCriterion("humidity is not null");
            return (Criteria) this;
        }

        public Criteria andHumidityEqualTo(String value) {
            addCriterion("humidity =", value, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityNotEqualTo(String value) {
            addCriterion("humidity <>", value, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityGreaterThan(String value) {
            addCriterion("humidity >", value, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityGreaterThanOrEqualTo(String value) {
            addCriterion("humidity >=", value, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityLessThan(String value) {
            addCriterion("humidity <", value, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityLessThanOrEqualTo(String value) {
            addCriterion("humidity <=", value, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityLike(String value) {
            addCriterion("humidity like", value, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityNotLike(String value) {
            addCriterion("humidity not like", value, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityIn(List<String> values) {
            addCriterion("humidity in", values, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityNotIn(List<String> values) {
            addCriterion("humidity not in", values, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityBetween(String value1, String value2) {
            addCriterion("humidity between", value1, value2, "humidity");
            return (Criteria) this;
        }

        public Criteria andHumidityNotBetween(String value1, String value2) {
            addCriterion("humidity not between", value1, value2, "humidity");
            return (Criteria) this;
        }
        
		
        public Criteria andAtmosphericIsNull() {
            addCriterion("atmospheric is null");
            return (Criteria) this;
        }

        public Criteria andAtmosphericIsNotNull() {
            addCriterion("atmospheric is not null");
            return (Criteria) this;
        }

        public Criteria andAtmosphericEqualTo(String value) {
            addCriterion("atmospheric =", value, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericNotEqualTo(String value) {
            addCriterion("atmospheric <>", value, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericGreaterThan(String value) {
            addCriterion("atmospheric >", value, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericGreaterThanOrEqualTo(String value) {
            addCriterion("atmospheric >=", value, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericLessThan(String value) {
            addCriterion("atmospheric <", value, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericLessThanOrEqualTo(String value) {
            addCriterion("atmospheric <=", value, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericLike(String value) {
            addCriterion("atmospheric like", value, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericNotLike(String value) {
            addCriterion("atmospheric not like", value, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericIn(List<String> values) {
            addCriterion("atmospheric in", values, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericNotIn(List<String> values) {
            addCriterion("atmospheric not in", values, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericBetween(String value1, String value2) {
            addCriterion("atmospheric between", value1, value2, "atmospheric");
            return (Criteria) this;
        }

        public Criteria andAtmosphericNotBetween(String value1, String value2) {
            addCriterion("atmospheric not between", value1, value2, "atmospheric");
            return (Criteria) this;
        }
        
		
        public Criteria andAirdensityIsNull() {
            addCriterion("airdensity is null");
            return (Criteria) this;
        }

        public Criteria andAirdensityIsNotNull() {
            addCriterion("airdensity is not null");
            return (Criteria) this;
        }

        public Criteria andAirdensityEqualTo(String value) {
            addCriterion("airdensity =", value, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityNotEqualTo(String value) {
            addCriterion("airdensity <>", value, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityGreaterThan(String value) {
            addCriterion("airdensity >", value, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityGreaterThanOrEqualTo(String value) {
            addCriterion("airdensity >=", value, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityLessThan(String value) {
            addCriterion("airdensity <", value, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityLessThanOrEqualTo(String value) {
            addCriterion("airdensity <=", value, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityLike(String value) {
            addCriterion("airdensity like", value, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityNotLike(String value) {
            addCriterion("airdensity not like", value, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityIn(List<String> values) {
            addCriterion("airdensity in", values, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityNotIn(List<String> values) {
            addCriterion("airdensity not in", values, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityBetween(String value1, String value2) {
            addCriterion("airdensity between", value1, value2, "airdensity");
            return (Criteria) this;
        }

        public Criteria andAirdensityNotBetween(String value1, String value2) {
            addCriterion("airdensity not between", value1, value2, "airdensity");
            return (Criteria) this;
        }
        
		
        public Criteria andStuffIsNull() {
            addCriterion("stuff is null");
            return (Criteria) this;
        }

        public Criteria andStuffIsNotNull() {
            addCriterion("stuff is not null");
            return (Criteria) this;
        }

        public Criteria andStuffEqualTo(String value) {
            addCriterion("stuff =", value, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffNotEqualTo(String value) {
            addCriterion("stuff <>", value, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffGreaterThan(String value) {
            addCriterion("stuff >", value, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffGreaterThanOrEqualTo(String value) {
            addCriterion("stuff >=", value, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffLessThan(String value) {
            addCriterion("stuff <", value, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffLessThanOrEqualTo(String value) {
            addCriterion("stuff <=", value, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffLike(String value) {
            addCriterion("stuff like", value, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffNotLike(String value) {
            addCriterion("stuff not like", value, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffIn(List<String> values) {
            addCriterion("stuff in", values, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffNotIn(List<String> values) {
            addCriterion("stuff not in", values, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffBetween(String value1, String value2) {
            addCriterion("stuff between", value1, value2, "stuff");
            return (Criteria) this;
        }

        public Criteria andStuffNotBetween(String value1, String value2) {
            addCriterion("stuff not between", value1, value2, "stuff");
            return (Criteria) this;
        }
        
		
        public Criteria andFileurlIsNull() {
            addCriterion("fileurl is null");
            return (Criteria) this;
        }

        public Criteria andFileurlIsNotNull() {
            addCriterion("fileurl is not null");
            return (Criteria) this;
        }

        public Criteria andFileurlEqualTo(String value) {
            addCriterion("fileurl =", value, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlNotEqualTo(String value) {
            addCriterion("fileurl <>", value, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlGreaterThan(String value) {
            addCriterion("fileurl >", value, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlGreaterThanOrEqualTo(String value) {
            addCriterion("fileurl >=", value, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlLessThan(String value) {
            addCriterion("fileurl <", value, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlLessThanOrEqualTo(String value) {
            addCriterion("fileurl <=", value, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlLike(String value) {
            addCriterion("fileurl like", value, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlNotLike(String value) {
            addCriterion("fileurl not like", value, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlIn(List<String> values) {
            addCriterion("fileurl in", values, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlNotIn(List<String> values) {
            addCriterion("fileurl not in", values, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlBetween(String value1, String value2) {
            addCriterion("fileurl between", value1, value2, "fileurl");
            return (Criteria) this;
        }

        public Criteria andFileurlNotBetween(String value1, String value2) {
            addCriterion("fileurl not between", value1, value2, "fileurl");
            return (Criteria) this;
        }
        
		
        public Criteria andAccordingIsNull() {
            addCriterion("according is null");
            return (Criteria) this;
        }

        public Criteria andAccordingIsNotNull() {
            addCriterion("according is not null");
            return (Criteria) this;
        }

        public Criteria andAccordingEqualTo(String value) {
            addCriterion("according =", value, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingNotEqualTo(String value) {
            addCriterion("according <>", value, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingGreaterThan(String value) {
            addCriterion("according >", value, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingGreaterThanOrEqualTo(String value) {
            addCriterion("according >=", value, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingLessThan(String value) {
            addCriterion("according <", value, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingLessThanOrEqualTo(String value) {
            addCriterion("according <=", value, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingLike(String value) {
            addCriterion("according like", value, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingNotLike(String value) {
            addCriterion("according not like", value, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingIn(List<String> values) {
            addCriterion("according in", values, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingNotIn(List<String> values) {
            addCriterion("according not in", values, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingBetween(String value1, String value2) {
            addCriterion("according between", value1, value2, "according");
            return (Criteria) this;
        }

        public Criteria andAccordingNotBetween(String value1, String value2) {
            addCriterion("according not between", value1, value2, "according");
            return (Criteria) this;
        }
        
		
        public Criteria andPreworkIsNull() {
            addCriterion("prework is null");
            return (Criteria) this;
        }

        public Criteria andPreworkIsNotNull() {
            addCriterion("prework is not null");
            return (Criteria) this;
        }

        public Criteria andPreworkEqualTo(String value) {
            addCriterion("prework =", value, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkNotEqualTo(String value) {
            addCriterion("prework <>", value, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkGreaterThan(String value) {
            addCriterion("prework >", value, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkGreaterThanOrEqualTo(String value) {
            addCriterion("prework >=", value, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkLessThan(String value) {
            addCriterion("prework <", value, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkLessThanOrEqualTo(String value) {
            addCriterion("prework <=", value, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkLike(String value) {
            addCriterion("prework like", value, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkNotLike(String value) {
            addCriterion("prework not like", value, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkIn(List<String> values) {
            addCriterion("prework in", values, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkNotIn(List<String> values) {
            addCriterion("prework not in", values, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkBetween(String value1, String value2) {
            addCriterion("prework between", value1, value2, "prework");
            return (Criteria) this;
        }

        public Criteria andPreworkNotBetween(String value1, String value2) {
            addCriterion("prework not between", value1, value2, "prework");
            return (Criteria) this;
        }
        
		
        public Criteria andAfterworkIsNull() {
            addCriterion("afterwork is null");
            return (Criteria) this;
        }

        public Criteria andAfterworkIsNotNull() {
            addCriterion("afterwork is not null");
            return (Criteria) this;
        }

        public Criteria andAfterworkEqualTo(String value) {
            addCriterion("afterwork =", value, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkNotEqualTo(String value) {
            addCriterion("afterwork <>", value, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkGreaterThan(String value) {
            addCriterion("afterwork >", value, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkGreaterThanOrEqualTo(String value) {
            addCriterion("afterwork >=", value, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkLessThan(String value) {
            addCriterion("afterwork <", value, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkLessThanOrEqualTo(String value) {
            addCriterion("afterwork <=", value, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkLike(String value) {
            addCriterion("afterwork like", value, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkNotLike(String value) {
            addCriterion("afterwork not like", value, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkIn(List<String> values) {
            addCriterion("afterwork in", values, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkNotIn(List<String> values) {
            addCriterion("afterwork not in", values, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkBetween(String value1, String value2) {
            addCriterion("afterwork between", value1, value2, "afterwork");
            return (Criteria) this;
        }

        public Criteria andAfterworkNotBetween(String value1, String value2) {
            addCriterion("afterwork not between", value1, value2, "afterwork");
            return (Criteria) this;
        }
        
		
        public Criteria andProjectIsNull() {
            addCriterion("project is null");
            return (Criteria) this;
        }

        public Criteria andProjectIsNotNull() {
            addCriterion("project is not null");
            return (Criteria) this;
        }

        public Criteria andProjectEqualTo(String value) {
            addCriterion("project =", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotEqualTo(String value) {
            addCriterion("project <>", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectGreaterThan(String value) {
            addCriterion("project >", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectGreaterThanOrEqualTo(String value) {
            addCriterion("project >=", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectLessThan(String value) {
            addCriterion("project <", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectLessThanOrEqualTo(String value) {
            addCriterion("project <=", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectLike(String value) {
            addCriterion("project like", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotLike(String value) {
            addCriterion("project not like", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectIn(List<String> values) {
            addCriterion("project in", values, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotIn(List<String> values) {
            addCriterion("project not in", values, "project");
            return (Criteria) this;
        }

        public Criteria andProjectBetween(String value1, String value2) {
            addCriterion("project between", value1, value2, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotBetween(String value1, String value2) {
            addCriterion("project not between", value1, value2, "project");
            return (Criteria) this;
        }
        
		
        public Criteria andInspectionsiteIsNull() {
            addCriterion("inspectionsite is null");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteIsNotNull() {
            addCriterion("inspectionsite is not null");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteEqualTo(String value) {
            addCriterion("inspectionsite =", value, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteNotEqualTo(String value) {
            addCriterion("inspectionsite <>", value, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteGreaterThan(String value) {
            addCriterion("inspectionsite >", value, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteGreaterThanOrEqualTo(String value) {
            addCriterion("inspectionsite >=", value, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteLessThan(String value) {
            addCriterion("inspectionsite <", value, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteLessThanOrEqualTo(String value) {
            addCriterion("inspectionsite <=", value, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteLike(String value) {
            addCriterion("inspectionsite like", value, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteNotLike(String value) {
            addCriterion("inspectionsite not like", value, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteIn(List<String> values) {
            addCriterion("inspectionsite in", values, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteNotIn(List<String> values) {
            addCriterion("inspectionsite not in", values, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteBetween(String value1, String value2) {
            addCriterion("inspectionsite between", value1, value2, "inspectionsite");
            return (Criteria) this;
        }

        public Criteria andInspectionsiteNotBetween(String value1, String value2) {
            addCriterion("inspectionsite not between", value1, value2, "inspectionsite");
            return (Criteria) this;
        }
        
		
        public Criteria andVerifierIsNull() {
            addCriterion("verifier is null");
            return (Criteria) this;
        }

        public Criteria andVerifierIsNotNull() {
            addCriterion("verifier is not null");
            return (Criteria) this;
        }

        public Criteria andVerifierEqualTo(String value) {
            addCriterion("verifier =", value, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierNotEqualTo(String value) {
            addCriterion("verifier <>", value, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierGreaterThan(String value) {
            addCriterion("verifier >", value, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierGreaterThanOrEqualTo(String value) {
            addCriterion("verifier >=", value, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierLessThan(String value) {
            addCriterion("verifier <", value, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierLessThanOrEqualTo(String value) {
            addCriterion("verifier <=", value, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierLike(String value) {
            addCriterion("verifier like", value, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierNotLike(String value) {
            addCriterion("verifier not like", value, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierIn(List<String> values) {
            addCriterion("verifier in", values, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierNotIn(List<String> values) {
            addCriterion("verifier not in", values, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierBetween(String value1, String value2) {
            addCriterion("verifier between", value1, value2, "verifier");
            return (Criteria) this;
        }

        public Criteria andVerifierNotBetween(String value1, String value2) {
            addCriterion("verifier not between", value1, value2, "verifier");
            return (Criteria) this;
        }
        
		
        public Criteria andCheckverIsNull() {
            addCriterion("checkver is null");
            return (Criteria) this;
        }

        public Criteria andCheckverIsNotNull() {
            addCriterion("checkver is not null");
            return (Criteria) this;
        }

        public Criteria andCheckverEqualTo(String value) {
            addCriterion("checkver =", value, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverNotEqualTo(String value) {
            addCriterion("checkver <>", value, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverGreaterThan(String value) {
            addCriterion("checkver >", value, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverGreaterThanOrEqualTo(String value) {
            addCriterion("checkver >=", value, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverLessThan(String value) {
            addCriterion("checkver <", value, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverLessThanOrEqualTo(String value) {
            addCriterion("checkver <=", value, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverLike(String value) {
            addCriterion("checkver like", value, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverNotLike(String value) {
            addCriterion("checkver not like", value, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverIn(List<String> values) {
            addCriterion("checkver in", values, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverNotIn(List<String> values) {
            addCriterion("checkver not in", values, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverBetween(String value1, String value2) {
            addCriterion("checkver between", value1, value2, "checkver");
            return (Criteria) this;
        }

        public Criteria andCheckverNotBetween(String value1, String value2) {
            addCriterion("checkver not between", value1, value2, "checkver");
            return (Criteria) this;
        }
        
		
        public Criteria andQdtimeIsNull() {
            addCriterion("qdtime is null");
            return (Criteria) this;
        }

        public Criteria andQdtimeIsNotNull() {
            addCriterion("qdtime is not null");
            return (Criteria) this;
        }

        public Criteria andQdtimeEqualTo(String value) {
            addCriterion("qdtime =", value, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeNotEqualTo(String value) {
            addCriterion("qdtime <>", value, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeGreaterThan(String value) {
            addCriterion("qdtime >", value, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeGreaterThanOrEqualTo(String value) {
            addCriterion("qdtime >=", value, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeLessThan(String value) {
            addCriterion("qdtime <", value, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeLessThanOrEqualTo(String value) {
            addCriterion("qdtime <=", value, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeLike(String value) {
            addCriterion("qdtime like", value, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeNotLike(String value) {
            addCriterion("qdtime not like", value, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeIn(List<String> values) {
            addCriterion("qdtime in", values, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeNotIn(List<String> values) {
            addCriterion("qdtime not in", values, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeBetween(String value1, String value2) {
            addCriterion("qdtime between", value1, value2, "qdtime");
            return (Criteria) this;
        }

        public Criteria andQdtimeNotBetween(String value1, String value2) {
            addCriterion("qdtime not between", value1, value2, "qdtime");
            return (Criteria) this;
        }
        
		
        public Criteria andYxtimeIsNull() {
            addCriterion("yxtime is null");
            return (Criteria) this;
        }

        public Criteria andYxtimeIsNotNull() {
            addCriterion("yxtime is not null");
            return (Criteria) this;
        }

        public Criteria andYxtimeEqualTo(String value) {
            addCriterion("yxtime =", value, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeNotEqualTo(String value) {
            addCriterion("yxtime <>", value, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeGreaterThan(String value) {
            addCriterion("yxtime >", value, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeGreaterThanOrEqualTo(String value) {
            addCriterion("yxtime >=", value, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeLessThan(String value) {
            addCriterion("yxtime <", value, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeLessThanOrEqualTo(String value) {
            addCriterion("yxtime <=", value, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeLike(String value) {
            addCriterion("yxtime like", value, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeNotLike(String value) {
            addCriterion("yxtime not like", value, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeIn(List<String> values) {
            addCriterion("yxtime in", values, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeNotIn(List<String> values) {
            addCriterion("yxtime not in", values, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeBetween(String value1, String value2) {
            addCriterion("yxtime between", value1, value2, "yxtime");
            return (Criteria) this;
        }

        public Criteria andYxtimeNotBetween(String value1, String value2) {
            addCriterion("yxtime not between", value1, value2, "yxtime");
            return (Criteria) this;
        }
        
		
        public Criteria andVerdictIsNull() {
            addCriterion("verdict is null");
            return (Criteria) this;
        }

        public Criteria andVerdictIsNotNull() {
            addCriterion("verdict is not null");
            return (Criteria) this;
        }

        public Criteria andVerdictEqualTo(String value) {
            addCriterion("verdict =", value, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictNotEqualTo(String value) {
            addCriterion("verdict <>", value, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictGreaterThan(String value) {
            addCriterion("verdict >", value, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictGreaterThanOrEqualTo(String value) {
            addCriterion("verdict >=", value, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictLessThan(String value) {
            addCriterion("verdict <", value, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictLessThanOrEqualTo(String value) {
            addCriterion("verdict <=", value, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictLike(String value) {
            addCriterion("verdict like", value, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictNotLike(String value) {
            addCriterion("verdict not like", value, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictIn(List<String> values) {
            addCriterion("verdict in", values, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictNotIn(List<String> values) {
            addCriterion("verdict not in", values, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictBetween(String value1, String value2) {
            addCriterion("verdict between", value1, value2, "verdict");
            return (Criteria) this;
        }

        public Criteria andVerdictNotBetween(String value1, String value2) {
            addCriterion("verdict not between", value1, value2, "verdict");
            return (Criteria) this;
        }
        
		
        public Criteria andCreatetimeIsNull() {
            addCriterion("createtime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createtime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createtime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createtime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createtime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createtime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createtime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createtime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLike(Date value) {
            addCriterion("createtime like", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotLike(Date value) {
            addCriterion("createtime not like", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createtime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createtime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createtime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createtime not between", value1, value2, "createtime");
            return (Criteria) this;
        }
        
		
        public Criteria andUpdatetimeIsNull() {
            addCriterion("updatetime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("updatetime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("updatetime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("updatetime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("updatetime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updatetime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("updatetime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("updatetime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLike(Date value) {
            addCriterion("updatetime like", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotLike(Date value) {
            addCriterion("updatetime not like", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("updatetime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("updatetime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("updatetime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("updatetime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }
        
	
		 public Criteria andLikeQuery(Detection record) {
		 	List<String> list= new ArrayList<String>();
		 	List<String> list2= new ArrayList<String>();
        	StringBuffer buffer=new StringBuffer();
			if(record.getId()!=null&&StrUtil.isNotEmpty(record.getId().toString())) {
    			 list.add("ifnull(id,'')");
    		}
			if(record.getCustomer()!=null&&StrUtil.isNotEmpty(record.getCustomer().toString())) {
    			 list.add("ifnull(customer,'')");
    		}
			if(record.getModelspecifications()!=null&&StrUtil.isNotEmpty(record.getModelspecifications().toString())) {
    			 list.add("ifnull(modelspecifications,'')");
    		}
			if(record.getTaskno()!=null&&StrUtil.isNotEmpty(record.getTaskno().toString())) {
    			 list.add("ifnull(taskno,'')");
    		}
			if(record.getManufacturer()!=null&&StrUtil.isNotEmpty(record.getManufacturer().toString())) {
    			 list.add("ifnull(manufacturer,'')");
    		}
			if(record.getMpe1()!=null&&StrUtil.isNotEmpty(record.getMpe1().toString())) {
    			 list.add("ifnull(mpe1,'')");
    		}
			if(record.getExitnum()!=null&&StrUtil.isNotEmpty(record.getExitnum().toString())) {
    			 list.add("ifnull(exitnum,'')");
    		}
			if(record.getMainstandard()!=null&&StrUtil.isNotEmpty(record.getMainstandard().toString())) {
    			 list.add("ifnull(mainstandard,'')");
    		}
			if(record.getMrange()!=null&&StrUtil.isNotEmpty(record.getMrange().toString())) {
    			 list.add("ifnull(mrange,'')");
    		}
			if(record.getMpe2()!=null&&StrUtil.isNotEmpty(record.getMpe2().toString())) {
    			 list.add("ifnull(mpe2,'')");
    		}
			if(record.getCertificateno()!=null&&StrUtil.isNotEmpty(record.getCertificateno().toString())) {
    			 list.add("ifnull(certificateno,'')");
    		}
			if(record.getSmw()!=null&&StrUtil.isNotEmpty(record.getSmw().toString())) {
    			 list.add("ifnull(smw,'')");
    		}
			if(record.getCertificateutil()!=null&&StrUtil.isNotEmpty(record.getCertificateutil().toString())) {
    			 list.add("ifnull(certificateutil,'')");
    		}
			if(record.getTemperature()!=null&&StrUtil.isNotEmpty(record.getTemperature().toString())) {
    			 list.add("ifnull(temperature,'')");
    		}
			if(record.getHumidity()!=null&&StrUtil.isNotEmpty(record.getHumidity().toString())) {
    			 list.add("ifnull(humidity,'')");
    		}
			if(record.getAtmospheric()!=null&&StrUtil.isNotEmpty(record.getAtmospheric().toString())) {
    			 list.add("ifnull(atmospheric,'')");
    		}
			if(record.getAirdensity()!=null&&StrUtil.isNotEmpty(record.getAirdensity().toString())) {
    			 list.add("ifnull(airdensity,'')");
    		}
			if(record.getStuff()!=null&&StrUtil.isNotEmpty(record.getStuff().toString())) {
    			 list.add("ifnull(stuff,'')");
    		}
			if(record.getFileurl()!=null&&StrUtil.isNotEmpty(record.getFileurl().toString())) {
    			 list.add("ifnull(fileurl,'')");
    		}
			if(record.getAccording()!=null&&StrUtil.isNotEmpty(record.getAccording().toString())) {
    			 list.add("ifnull(according,'')");
    		}
			if(record.getPrework()!=null&&StrUtil.isNotEmpty(record.getPrework().toString())) {
    			 list.add("ifnull(prework,'')");
    		}
			if(record.getAfterwork()!=null&&StrUtil.isNotEmpty(record.getAfterwork().toString())) {
    			 list.add("ifnull(afterwork,'')");
    		}
			if(record.getProject()!=null&&StrUtil.isNotEmpty(record.getProject().toString())) {
    			 list.add("ifnull(project,'')");
    		}
			if(record.getInspectionsite()!=null&&StrUtil.isNotEmpty(record.getInspectionsite().toString())) {
    			 list.add("ifnull(inspectionsite,'')");
    		}
			if(record.getVerifier()!=null&&StrUtil.isNotEmpty(record.getVerifier().toString())) {
    			 list.add("ifnull(verifier,'')");
    		}
			if(record.getCheckver()!=null&&StrUtil.isNotEmpty(record.getCheckver().toString())) {
    			 list.add("ifnull(checkver,'')");
    		}
			if(record.getQdtime()!=null&&StrUtil.isNotEmpty(record.getQdtime().toString())) {
    			 list.add("ifnull(qdtime,'')");
    		}
			if(record.getYxtime()!=null&&StrUtil.isNotEmpty(record.getYxtime().toString())) {
    			 list.add("ifnull(yxtime,'')");
    		}
			if(record.getVerdict()!=null&&StrUtil.isNotEmpty(record.getVerdict().toString())) {
    			 list.add("ifnull(verdict,'')");
    		}
			if(record.getCreatetime()!=null&&StrUtil.isNotEmpty(record.getCreatetime().toString())) {
    			 list.add("ifnull(createtime,'')");
    		}
			if(record.getUpdatetime()!=null&&StrUtil.isNotEmpty(record.getUpdatetime().toString())) {
    			 list.add("ifnull(updatetime,'')");
    		}
			if(record.getId()!=null&&StrUtil.isNotEmpty(record.getId().toString())) {
    			list2.add("'%"+record.getId()+"%'");
    		}
			if(record.getCustomer()!=null&&StrUtil.isNotEmpty(record.getCustomer().toString())) {
    			list2.add("'%"+record.getCustomer()+"%'");
    		}
			if(record.getModelspecifications()!=null&&StrUtil.isNotEmpty(record.getModelspecifications().toString())) {
    			list2.add("'%"+record.getModelspecifications()+"%'");
    		}
			if(record.getTaskno()!=null&&StrUtil.isNotEmpty(record.getTaskno().toString())) {
    			list2.add("'%"+record.getTaskno()+"%'");
    		}
			if(record.getManufacturer()!=null&&StrUtil.isNotEmpty(record.getManufacturer().toString())) {
    			list2.add("'%"+record.getManufacturer()+"%'");
    		}
			if(record.getMpe1()!=null&&StrUtil.isNotEmpty(record.getMpe1().toString())) {
    			list2.add("'%"+record.getMpe1()+"%'");
    		}
			if(record.getExitnum()!=null&&StrUtil.isNotEmpty(record.getExitnum().toString())) {
    			list2.add("'%"+record.getExitnum()+"%'");
    		}
			if(record.getMainstandard()!=null&&StrUtil.isNotEmpty(record.getMainstandard().toString())) {
    			list2.add("'%"+record.getMainstandard()+"%'");
    		}
			if(record.getMrange()!=null&&StrUtil.isNotEmpty(record.getMrange().toString())) {
    			list2.add("'%"+record.getMrange()+"%'");
    		}
			if(record.getMpe2()!=null&&StrUtil.isNotEmpty(record.getMpe2().toString())) {
    			list2.add("'%"+record.getMpe2()+"%'");
    		}
			if(record.getCertificateno()!=null&&StrUtil.isNotEmpty(record.getCertificateno().toString())) {
    			list2.add("'%"+record.getCertificateno()+"%'");
    		}
			if(record.getSmw()!=null&&StrUtil.isNotEmpty(record.getSmw().toString())) {
    			list2.add("'%"+record.getSmw()+"%'");
    		}
			if(record.getCertificateutil()!=null&&StrUtil.isNotEmpty(record.getCertificateutil().toString())) {
    			list2.add("'%"+record.getCertificateutil()+"%'");
    		}
			if(record.getTemperature()!=null&&StrUtil.isNotEmpty(record.getTemperature().toString())) {
    			list2.add("'%"+record.getTemperature()+"%'");
    		}
			if(record.getHumidity()!=null&&StrUtil.isNotEmpty(record.getHumidity().toString())) {
    			list2.add("'%"+record.getHumidity()+"%'");
    		}
			if(record.getAtmospheric()!=null&&StrUtil.isNotEmpty(record.getAtmospheric().toString())) {
    			list2.add("'%"+record.getAtmospheric()+"%'");
    		}
			if(record.getAirdensity()!=null&&StrUtil.isNotEmpty(record.getAirdensity().toString())) {
    			list2.add("'%"+record.getAirdensity()+"%'");
    		}
			if(record.getStuff()!=null&&StrUtil.isNotEmpty(record.getStuff().toString())) {
    			list2.add("'%"+record.getStuff()+"%'");
    		}
			if(record.getFileurl()!=null&&StrUtil.isNotEmpty(record.getFileurl().toString())) {
    			list2.add("'%"+record.getFileurl()+"%'");
    		}
			if(record.getAccording()!=null&&StrUtil.isNotEmpty(record.getAccording().toString())) {
    			list2.add("'%"+record.getAccording()+"%'");
    		}
			if(record.getPrework()!=null&&StrUtil.isNotEmpty(record.getPrework().toString())) {
    			list2.add("'%"+record.getPrework()+"%'");
    		}
			if(record.getAfterwork()!=null&&StrUtil.isNotEmpty(record.getAfterwork().toString())) {
    			list2.add("'%"+record.getAfterwork()+"%'");
    		}
			if(record.getProject()!=null&&StrUtil.isNotEmpty(record.getProject().toString())) {
    			list2.add("'%"+record.getProject()+"%'");
    		}
			if(record.getInspectionsite()!=null&&StrUtil.isNotEmpty(record.getInspectionsite().toString())) {
    			list2.add("'%"+record.getInspectionsite()+"%'");
    		}
			if(record.getVerifier()!=null&&StrUtil.isNotEmpty(record.getVerifier().toString())) {
    			list2.add("'%"+record.getVerifier()+"%'");
    		}
			if(record.getCheckver()!=null&&StrUtil.isNotEmpty(record.getCheckver().toString())) {
    			list2.add("'%"+record.getCheckver()+"%'");
    		}
			if(record.getQdtime()!=null&&StrUtil.isNotEmpty(record.getQdtime().toString())) {
    			list2.add("'%"+record.getQdtime()+"%'");
    		}
			if(record.getYxtime()!=null&&StrUtil.isNotEmpty(record.getYxtime().toString())) {
    			list2.add("'%"+record.getYxtime()+"%'");
    		}
			if(record.getVerdict()!=null&&StrUtil.isNotEmpty(record.getVerdict().toString())) {
    			list2.add("'%"+record.getVerdict()+"%'");
    		}
			if(record.getCreatetime()!=null&&StrUtil.isNotEmpty(record.getCreatetime().toString())) {
    			list2.add("'%"+record.getCreatetime()+"%'");
    		}
			if(record.getUpdatetime()!=null&&StrUtil.isNotEmpty(record.getUpdatetime().toString())) {
    			list2.add("'%"+record.getUpdatetime()+"%'");
    		}
        	buffer.append(" CONCAT(");
	        buffer.append(StrUtil.join(",",list));
        	buffer.append(")");
        	buffer.append(" like CONCAT(");
        	buffer.append(StrUtil.join(",",list2));
        	buffer.append(")");
        	if(!" CONCAT() like CONCAT()".equals(buffer.toString())) {
        		addCriterion(buffer.toString());
        	}
        	return (Criteria) this;
        }
        
        public Criteria andLikeQuery2(String searchText) {
		 	List<String> list= new ArrayList<String>();
        	StringBuffer buffer=new StringBuffer();
    		list.add("ifnull(id,'')");
    		list.add("ifnull(customer,'')");
    		list.add("ifnull(modelspecifications,'')");
    		list.add("ifnull(taskno,'')");
    		list.add("ifnull(manufacturer,'')");
    		list.add("ifnull(mpe1,'')");
    		list.add("ifnull(exitnum,'')");
    		list.add("ifnull(mainstandard,'')");
    		list.add("ifnull(mrange,'')");
    		list.add("ifnull(mpe2,'')");
    		list.add("ifnull(certificateno,'')");
    		list.add("ifnull(smw,'')");
    		list.add("ifnull(certificateutil,'')");
    		list.add("ifnull(temperature,'')");
    		list.add("ifnull(humidity,'')");
    		list.add("ifnull(atmospheric,'')");
    		list.add("ifnull(airdensity,'')");
    		list.add("ifnull(stuff,'')");
    		list.add("ifnull(fileurl,'')");
    		list.add("ifnull(according,'')");
    		list.add("ifnull(prework,'')");
    		list.add("ifnull(afterwork,'')");
    		list.add("ifnull(project,'')");
    		list.add("ifnull(inspectionsite,'')");
    		list.add("ifnull(verifier,'')");
    		list.add("ifnull(checkver,'')");
    		list.add("ifnull(qdtime,'')");
    		list.add("ifnull(yxtime,'')");
    		list.add("ifnull(verdict,'')");
    		list.add("ifnull(createtime,'')");
    		list.add("ifnull(updatetime,'')");
        	buffer.append(" CONCAT(");
	        buffer.append(StrUtil.join(",",list));
        	buffer.append(")");
        	buffer.append("like '%");
        	buffer.append(searchText);
        	buffer.append("%'");
        	addCriterion(buffer.toString());
        	return (Criteria) this;
        }
        
}
	
    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
        // 省略其他代码
        public Criteria andRelatedIdEqualTo(Integer value) {
            addCriterion("id =", value, "read2");
            return this;
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}